Prerequisites
To use Microsoft Azure Database for MySQL as an endpoint in a Qlik Replicate task, make sure the prerequisites outlined below have been met.
Client prerequisites
Install MySQL ODBC Unicode Driver 64-bit on the Replicate Server machine.
Only these driver versions are supported:
- 5.3.11 to 5.3.13
- 8.0.23
Linux only:
Make sure that the /etc/odbcinst.ini file contains an entry for MySQL, as in the following example:
[MySQL ODBC 8.0 Unicode Driver]
Driver = /usr/lib64/libmyodbc8w.so
UsageCount = 1
Verifying that Microsoft Azure database for MySQL is set up for CDC (Change data capture)
Microsoft Azure Database for MySQL enables binary logging (i.e. CDC) by default. To check that binary logging is indeed enabled, make sure that the Microsoft Azure Database for MySQL binlog_row_image
parameter is set to full
.
Replicating 4-byte UTF8 emojis
Replication of 4-byte UTF8 emojis to certain targets requires the following preparation:
- Microsoft SQL Server Target: Transform the emojis from
WSTRING(n)
toWSTRING(n*2)
. - Amazon Redshift Target: Transform the emojis from
WSTRING(n)
toWSTRING(n*2)
.
For information on defining transformations, see Using the Transform tab.